/****** Object:  Table [dbo].[DB_EnergyTypeInfo]    Script Date: 11/21/2011 10:08:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DB_EnergyTypeInfo](
	[EnergyTypeNo] [char](2) NOT NULL,
	[EnergyTypeName] [varchar](32) NULL,
	[EnergyTypeUnit] [varchar](16) NULL,
	[EnergyUnitPrice] [smallmoney] NULL,
	[EnergyTypeFml] [numeric](10, 4) NULL,
	[Multiple] [int] NULL,
	[IsAutoGather] [bit] NULL,
	[IsDelete] [bit] NULL,
	[hasSubItem] [bit] NULL,
 CONSTRAINT [PK_DB_EnergyTypeInfo] PRIMARY KEY CLUSTERED 
(
	[EnergyTypeNo] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[DB_DistrictCodeInfo]    Script Date: 11/21/2011 10:08:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DB_DistrictCodeInfo](
	[DistrictCode] [char](6) NOT NULL,
	[DistrictName] [varchar](32) NULL,
 CONSTRAINT [PK_DB_DistrictCodeInfo] PRIMARY KEY CLUSTERED 
(
	[DistrictCode] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[DB_OrganizeBaseInfo]    Script Date: 11/21/2011 10:08:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DB_OrganizeBaseInfo](
	[OrganizeID] [bigint] NOT NULL,
	[OrganizeCode] [varchar](20) NULL,
	[OrganizeName] [varchar](32) NULL,
	[OrganizeProperty] [char](2) NULL,
	[OrganizeIdentify] [char](3) NULL,
	[Postalcode] [char](6) NULL,
	[PhoneNum] [varchar](16) NULL,
	[FaxNum] [varchar](16) NULL,
	[EMailBox] [varchar](32) NULL,
	[OrganizeAddress] [varchar](64) NULL,
	[DistrictCode] [char](6) NULL,
	[IndustryCode] [char](5) NULL,
	[OrganizeLeader] [varchar](16) NULL,
	[StatistLeader] [varchar](16) NULL,
	[BuildYear] [int] NULL,
	[BuildDirection] [varchar](16) NULL,
	[BuildFloor] [int] NULL,
	[BuildHeight] [int] NULL,
	[BuildingLong] [numeric](18, 4) NULL,
	[BuildingLat] [numeric](18, 4) NULL,
	[BuildingBodyCoef] [numeric](18, 4) NULL,
	[BuildingAirType] [varchar](1) NULL,
	[BuildHeatType] [varchar](1) NULL,
	[BuildWallMatType] [varchar](1) NULL,
	[BuildWallWinType] [varchar](1) NULL,
	[BuildWinFrameType] [varchar](1) NULL,
	[BuildStruType] [varchar](1) NULL,
	[BuildWallWarmType] [varchar](1) NULL,
	[BuildGlassType] [varchar](1) NULL,
	[BuildNote] [varchar](256) NULL,
 CONSTRAINT [PK_DB_OrganizeInfo] PRIMARY KEY CLUSTERED 
(
	[OrganizeID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[DB_OrganizeExInfo]    Script Date: 11/21/2011 10:08:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DB_OrganizeExInfo](
	[OrganizeID] [bigint] NOT NULL,
	[BuildingArea] [numeric](18, 2) NULL,
	[GroundArea] [numeric](18, 2) NULL,
	[GreenbeltArea] [numeric](18, 2) NULL,
	[AirConArea] [numeric](18, 2) NULL,
	[HeatArea] [numeric](18, 2) NULL,
	[UserNum] [int] NULL,
	[AcademyNum] [int] NULL,
	[UGraduateNum] [int] NULL,
	[GraduateNum] [int] NULL,
	[TeacherNum] [int] NULL,
	[ElectroDevicePower] [numeric](18, 2) NULL,
	[StartDate] [datetime] NOT NULL,
	[EndDate] [datetime] NULL,
 CONSTRAINT [PK_DB_OrganizeExInfo] PRIMARY KEY CLUSTERED 
(
	[OrganizeID] ASC,
	[StartDate] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[DB_OrganizePropertyInfo]    Script Date: 11/21/2011 10:08:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DB_OrganizePropertyInfo](
	[OrgPropertyCode] [char](2) NOT NULL,
	[OrgPropertyName] [varchar](32) NULL,
 CONSTRAINT [PK_DB_OrganizePropertyInfo] PRIMARY KEY CLUSTERED 
(
	[OrgPropertyCode] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[DB_EnergyItemInfo]    Script Date: 11/21/2011 10:08:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DB_EnergyItemInfo](
	[EnergyTypeNo] [char](2) NOT NULL,
	[EnergyItemNo] [char](1) NOT NULL,
	[EnergyItemName] [varchar](32) NULL,
	[EnergyUnitPrice] [smallmoney] NULL,
	[IsDelete] [bit] NULL,
	[hasSubItem] [bit] NULL,
 CONSTRAINT [PK_DB_EnergyItemInfo] PRIMARY KEY CLUSTERED 
(
	[EnergyTypeNo] ASC,
	[EnergyItemNo] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[DB_EnergyOneSubItemInfo]    Script Date: 11/21/2011 10:08:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DB_EnergyOneSubItemInfo](
	[EnergyTypeNo] [char](2) NOT NULL,
	[EnergyItemNo] [char](1) NOT NULL,
	[EnergyOneSubItemNo] [char](1) NOT NULL,
	[EnergyOneSubItemName] [varchar](32) NULL,
	[EnergyUnitPrice] [smallmoney] NULL,
	[IsDelete] [bit] NULL,
	[hasSubItem] [bit] NULL,
 CONSTRAINT [PK_DB_EnergyOneSubItemInfo] PRIMARY KEY CLUSTERED 
(
	[EnergyTypeNo] ASC,
	[EnergyItemNo] ASC,
	[EnergyOneSubItemNo] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[DB_EnergyTwoSubItemInfo]    Script Date: 11/21/2011 10:08:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DB_EnergyTwoSubItemInfo](
	[EnergyTypeNo] [char](2) NOT NULL,
	[EnergyItemNo] [char](1) NOT NULL,
	[EnergyOneSubItemNo] [char](1) NOT NULL,
	[EnergyTwoSubItemNo] [char](1) NOT NULL,
	[EnergyTwoSubItemName] [varchar](32) NULL,
	[EnergyUnitPrice] [smallmoney] NULL,
	[IsDelete] [bit] NULL,
 CONSTRAINT [PK_DB_EnergyTwoSubItemInfo] PRIMARY KEY CLUSTERED 
(
	[EnergyTypeNo] ASC,
	[EnergyItemNo] ASC,
	[EnergyOneSubItemNo] ASC,
	[EnergyTwoSubItemNo] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[DB_HeatDayDatas]    Script Date: 11/21/2011 10:08:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DB_HeatDayDatas](
	[HeatNodeID] [bigint] NOT NULL,
	[ReadingYear] [int] NOT NULL,
	[ReadingMonth] [int] NOT NULL,
	[ReadingDay] [int] NOT NULL,
	[ReadingBeginDate] [datetime] NULL,
	[ReadingEndDate] [datetime] NULL,
	[OldDayData] [numeric](18, 2) NULL,
	[NewDayData] [numeric](18, 2) NULL,
	[DayTotalData] [numeric](18, 2) NULL,
	[WorkingData] [numeric](18, 2) NULL,
	[UnworkingData] [numeric](18, 2) NULL,
	[HeatPrice] [smallmoney] NULL,
	[DistrictCode] [char](6) NULL,
	[PropertyCode] [char](2) NULL,
	[IdentifyCode] [char](3) NULL,
	[EnergyTypeNo] [char](2) NULL,
	[EnergyItemNo] [char](1) NULL,
	[EnergyOneSubItemNo] [char](1) NULL,
	[EnergyTwoSubItemNo] [char](1) NULL,
	[ModifyUserID] [varchar](32) NULL,
	[ModifyDate] [datetime] NULL,
	[IsHoliday] [bit] NULL,
	[IsIntoComputation] [bit] NULL,
 CONSTRAINT [PK_DB_HeatDayDatas] PRIMARY KEY CLUSTERED 
(
	[HeatNodeID] ASC,
	[ReadingYear] ASC,
	[ReadingMonth] ASC,
	[ReadingDay] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[DB_HeatMonthDatas]    Script Date: 11/21/2011 10:08:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DB_HeatMonthDatas](
	[HeatNodeID] [bigint] NOT NULL,
	[ReadingYear] [int] NOT NULL,
	[ReadingMonth] [int] NOT NULL,
	[DistrictCode] [char](6) NOT NULL,
	[PropertyCode] [char](2) NOT NULL,
	[IdentifyCode] [char](3) NOT NULL,
	[EnergyTypeNo] [char](2) NOT NULL,
	[EnergyItemNo] [char](1) NOT NULL,
	[EnergyOneSubItemNo] [char](1) NOT NULL,
	[EnergyTwoSubItemNo] [char](1) NOT NULL,
	[MonthData] [numeric](18, 2) NULL,
	[WorkingData] [numeric](18, 2) NULL,
	[UnworkingData] [numeric](18, 2) NULL,
	[MonthMoney] [money] NULL,
 CONSTRAINT [PK_DB_HeatMonthDatas] PRIMARY KEY CLUSTERED 
(
	[HeatNodeID] ASC,
	[ReadingYear] ASC,
	[ReadingMonth] ASC,
	[DistrictCode] ASC,
	[PropertyCode] ASC,
	[IdentifyCode] ASC,
	[EnergyTypeNo] ASC,
	[EnergyItemNo] ASC,
	[EnergyOneSubItemNo] ASC,
	[EnergyTwoSubItemNo] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[DB_WaterDayDatas]    Script Date: 11/21/2011 10:08:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DB_WaterDayDatas](
	[WaterNodeID] [bigint] NOT NULL,
	[ReadingYear] [int] NOT NULL,
	[ReadingMonth] [int] NOT NULL,
	[ReadingDay] [int] NOT NULL,
	[ReadingBeginDate] [datetime] NULL,
	[ReadingEndDate] [datetime] NULL,
	[OldDayData] [numeric](18, 2) NULL,
	[NewDayData] [numeric](18, 2) NULL,
	[DayTotalData] [numeric](18, 2) NULL,
	[WorkingData] [numeric](18, 2) NULL,
	[UnworkingData] [numeric](18, 2) NULL,
	[WaterPrice] [smallmoney] NULL,
	[DistrictCode] [char](6) NULL,
	[PropertyCode] [char](2) NULL,
	[IdentifyCode] [char](3) NULL,
	[EnergyTypeNo] [char](2) NULL,
	[EnergyItemNo] [char](1) NULL,
	[EnergyOneSubItemNo] [char](1) NULL,
	[EnergyTwoSubItemNo] [char](1) NULL,
	[ModifyUserID] [varchar](32) NULL,
	[ModifyDate] [datetime] NULL,
	[IsHoliday] [bit] NOT NULL,
	[IsIntoComputation] [bit] NULL,
 CONSTRAINT [PK_DB_WaterDayDatas_1] PRIMARY KEY CLUSTERED 
(
	[WaterNodeID] ASC,
	[ReadingYear] ASC,
	[ReadingMonth] ASC,
	[ReadingDay] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[DB_WaterMonthDatas]    Script Date: 11/21/2011 10:08:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DB_WaterMonthDatas](
	[WaterNodeID] [bigint] NOT NULL,
	[ReadingYear] [int] NOT NULL,
	[ReadingMonth] [int] NOT NULL,
	[DistrictCode] [char](6) NOT NULL,
	[PropertyCode] [char](2) NOT NULL,
	[IdentifyCode] [char](3) NOT NULL,
	[EnergyTypeNo] [char](2) NOT NULL,
	[EnergyItemNo] [char](1) NOT NULL,
	[EnergyOneSubItemNo] [char](1) NOT NULL,
	[EnergyTwoSubItemNo] [char](1) NOT NULL,
	[MonthData] [numeric](18, 2) NULL,
	[WorkingData] [numeric](18, 2) NULL,
	[UnworkingData] [numeric](18, 2) NULL,
	[MonthMoney] [money] NULL,
 CONSTRAINT [PK_DB_WaterMonthDatas] PRIMARY KEY CLUSTERED 
(
	[WaterNodeID] ASC,
	[ReadingYear] ASC,
	[ReadingMonth] ASC,
	[DistrictCode] ASC,
	[PropertyCode] ASC,
	[IdentifyCode] ASC,
	[EnergyTypeNo] ASC,
	[EnergyItemNo] ASC,
	[EnergyOneSubItemNo] ASC,
	[EnergyTwoSubItemNo] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[DB_AmmeterDayDatas]    Script Date: 11/21/2011 10:08:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DB_AmmeterDayDatas](
	[AmmeterNodeID] [bigint] NOT NULL,
	[ReadingYear] [int] NOT NULL,
	[ReadingMonth] [int] NOT NULL,
	[ReadingDay] [int] NOT NULL,
	[ReadingBeginDate] [datetime] NULL,
	[ReadingEndDate] [datetime] NULL,
	[OldDayData] [numeric](18, 2) NULL,
	[NewDayData] [numeric](18, 2) NULL,
	[DayTotalData] [numeric](18, 2) NULL,
	[WorkingData] [numeric](18, 2) NULL,
	[UnworkingData] [numeric](18, 2) NULL,
	[AmmeterPrice] [smallmoney] NULL,
	[DistrictCode] [char](6) NULL,
	[PropertyCode] [char](2) NULL,
	[IdentifyCode] [char](3) NULL,
	[EnergyTypeNo] [char](2) NULL,
	[EnergyItemNo] [char](1) NULL,
	[EnergyOneSubItemNo] [char](1) NULL,
	[EnergyTwoSubItemNo] [char](1) NULL,
	[ModifyUserID] [varchar](32) NULL,
	[ModifyDate] [datetime] NULL,
	[IsHoliday] [bit] NULL,
	[IsIntoComputation] [bit] NULL,
 CONSTRAINT [PK_DB_AmmeterDayDatas] PRIMARY KEY CLUSTERED 
(
	[AmmeterNodeID] ASC,
	[ReadingYear] ASC,
	[ReadingMonth] ASC,
	[ReadingDay] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[DB_AmmeterMonthDatas]    Script Date: 11/21/2011 10:08:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DB_AmmeterMonthDatas](
	[AmmeterNodeID] [bigint] NOT NULL,
	[ReadingYear] [int] NOT NULL,
	[ReadingMonth] [int] NOT NULL,
	[DistrictCode] [char](6) NOT NULL,
	[PropertyCode] [char](2) NOT NULL,
	[IdentifyCode] [char](3) NOT NULL,
	[EnergyTypeNo] [char](2) NOT NULL,
	[EnergyItemNo] [char](1) NOT NULL,
	[EnergyOneSubItemNo] [char](1) NOT NULL,
	[EnergyTwoSubItemNo] [char](1) NOT NULL,
	[MonthData] [numeric](18, 2) NOT NULL,
	[WorkingData] [numeric](18, 2) NOT NULL,
	[UnworkingData] [numeric](18, 2) NOT NULL,
	[MonthMoney] [money] NULL,
 CONSTRAINT [PK_DB_AmmeterMonthDatas] PRIMARY KEY CLUSTERED 
(
	[AmmeterNodeID] ASC,
	[ReadingYear] ASC,
	[ReadingMonth] ASC,
	[DistrictCode] ASC,
	[PropertyCode] ASC,
	[IdentifyCode] ASC,
	[EnergyTypeNo] ASC,
	[EnergyItemNo] ASC,
	[EnergyOneSubItemNo] ASC,
	[EnergyTwoSubItemNo] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[DB_GasDayDatas]    Script Date: 11/21/2011 10:08:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DB_GasDayDatas](
	[GasNodeID] [bigint] NOT NULL,
	[ReadingYear] [int] NOT NULL,
	[ReadingMonth] [int] NOT NULL,
	[ReadingDay] [int] NOT NULL,
	[ReadingBeginDate] [datetime] NULL,
	[ReadingEndDate] [datetime] NULL,
	[OldDayData] [numeric](18, 2) NULL,
	[NewDayData] [numeric](18, 2) NULL,
	[DayTotalData] [numeric](18, 2) NULL,
	[WorkingData] [numeric](18, 2) NULL,
	[UnworkingData] [numeric](18, 2) NULL,
	[GasPrice] [smallmoney] NULL,
	[DistrictCode] [char](6) NULL,
	[PropertyCode] [char](2) NULL,
	[IdentifyCode] [char](3) NULL,
	[EnergyTypeNo] [char](2) NULL,
	[EnergyItemNo] [char](1) NULL,
	[EnergyOneSubItemNo] [char](1) NULL,
	[EnergyTwoSubItemNo] [char](1) NULL,
	[ModifyUserID] [varchar](32) NULL,
	[ModifyDate] [datetime] NULL,
	[IsHoliday] [bit] NULL,
	[IsIntoComputation] [bit] NULL,
 CONSTRAINT [PK_DB_GasDayDatas] PRIMARY KEY CLUSTERED 
(
	[GasNodeID] ASC,
	[ReadingYear] ASC,
	[ReadingMonth] ASC,
	[ReadingDay] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[DB_GasMonthDatas]    Script Date: 11/21/2011 10:08:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DB_GasMonthDatas](
	[GasNodeID] [bigint] NOT NULL,
	[ReadingYear] [int] NOT NULL,
	[ReadingMonth] [int] NOT NULL,
	[DistrictCode] [char](6) NOT NULL,
	[PropertyCode] [char](2) NOT NULL,
	[IdentifyCode] [char](3) NOT NULL,
	[EnergyTypeNo] [char](2) NOT NULL,
	[EnergyItemNo] [char](1) NOT NULL,
	[EnergyOneSubItemNo] [char](1) NOT NULL,
	[EnergyTwoSubItemNo] [char](1) NOT NULL,
	[MonthData] [numeric](18, 2) NULL,
	[WorkingData] [numeric](18, 2) NULL,
	[UnworkingData] [numeric](18, 2) NULL,
	[MonthMoney] [money] NULL,
 CONSTRAINT [PK_DB_GasMonthDatas] PRIMARY KEY CLUSTERED 
(
	[GasNodeID] ASC,
	[ReadingYear] ASC,
	[ReadingMonth] ASC,
	[DistrictCode] ASC,
	[PropertyCode] ASC,
	[IdentifyCode] ASC,
	[EnergyTypeNo] ASC,
	[EnergyItemNo] ASC,
	[EnergyOneSubItemNo] ASC,
	[EnergyTwoSubItemNo] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[DB_WorkingTimeInfo]    Script Date: 11/21/2011 10:08:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[DB_WorkingTimeInfo](
	[WorkingStartTime] [varchar](8) NOT NULL,
	[WorkingEndTime] [varchar](8) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO